Oil Reports

Dataset statistics

Number of variables	9
Number of observations	590
Missing cells	1494
Missing cells (%)	28.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	41.6 KiB
Average record size in memory	72.2 B

Variable types

DateTime	1
Numeric	8

Dataset

Description	Reports of cleaned oil dataset
URL

Variable descriptions

Leaded Regular Gasoline, U.S. City Average Retail Price	Price of leaded fuel, 0 when discontinued
Unleaded Regular Gasoline, U.S. City Average Retail Price	Price of unleaded fuel, 0 when leaded was used
Unleaded Premium Gasoline, U.S. City Average Retail Price	Price of premium unleaded fuel
All Grades of Gasoline, U.S. City Average Retail Price	Cumulative of all grades of gasoline
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price	Price of fuel, non-blended
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price	Price of fuel, blended
Regular Motor Gasoline, All Areas, Retail Price	Cumulative mean of all categories
On-Highway Diesel Fuel Price	Price for diesel fuel

Alerts

`Leaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 2 other fields	High correlation
`Unleaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Unleaded Premium Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`All Grades of Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, All Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`On-Highway Diesel Fuel Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Leaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 2 other fields	High correlation
`Unleaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Unleaded Premium Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`All Grades of Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, All Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`On-Highway Diesel Fuel Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Leaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 2 other fields	High correlation
`Unleaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Unleaded Premium Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`All Grades of Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, All Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`On-Highway Diesel Fuel Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Leaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 2 other fields	High correlation
`Unleaded Regular Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Unleaded Premium Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`All Grades of Gasoline, U.S. City Average Retail Price` is highly correlated with `Leaded Regular Gasoline, U.S. City Average Retail Price` and 6 other fields	High correlation
`Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Regular Motor Gasoline, All Areas, Retail Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`On-Highway Diesel Fuel Price` is highly correlated with `Unleaded Regular Gasoline, U.S. City Average Retail Price` and 5 other fields	High correlation
`Leaded Regular Gasoline, U.S. City Average Retail Price` has 370 (62.7%) missing values	Missing
`Unleaded Regular Gasoline, U.S. City Average Retail Price` has 36 (6.1%) missing values	Missing
`Unleaded Premium Gasoline, U.S. City Average Retail Price` has 104 (17.6%) missing values	Missing
`Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price` has 228 (38.6%) missing values	Missing
`Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price` has 264 (44.7%) missing values	Missing
`Regular Motor Gasoline, All Areas, Retail Price` has 228 (38.6%) missing values	Missing
`On-Highway Diesel Fuel Price` has 264 (44.7%) missing values	Missing
`Date` has unique values	Unique

Reproduction

Analysis started	2022-08-10 09:18:16.613359
Analysis finished	2022-08-10 09:18:25.240754
Duration	8.63 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Date
Date

UNIQUE

Distinct	590
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.7 KiB

Minimum	1973-01-01 00:00:00
Maximum	2022-02-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Leaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price of leaded fuel, 0 when discontinued

Distinct	181
Distinct (%)	82.3%
Missing	370
Missing (%)	62.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.9052363636

Minimum	0.402
Maximum	1.354
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.402
5-th percentile	0.5318
Q1	0.61175
median	0.9255
Q3	1.14425
95-th percentile	1.2993
Maximum	1.354
Range	0.952
Interquartile range (IQR)	0.5325

Descriptive statistics

Standard deviation	0.2703439861
Coefficient of variation (CV)	0.298644638
Kurtosis	-1.39437006
Mean	0.9052363636
Median Absolute Deviation (MAD)	0.265
Skewness	-0.1098260417
Sum	199.152
Variance	0.07308587082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.55	5	0.8%
0.528	4	0.7%
1.197	3	0.5%
1.297	2	0.3%
0.6	2	0.3%
0.607	2	0.3%
0.626	2	0.3%
0.63	2	0.3%
0.629	2	0.3%
0.627	2	0.3%
Other values (171)	194	32.9%
(Missing)	370	62.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.402	1	0.2%
0.418	1	0.2%
0.437	1	0.2%
0.465	2	0.3%
0.491	2	0.3%
0.528	4	0.7%
0.532	1	0.2%
0.533	1	0.2%
0.534	2	0.3%
0.537	2	0.3%

Value	Count	Frequency (%)
1.354	1	0.2%
1.352	1	0.2%
1.351	1	0.2%
1.344	1	0.2%
1.335	1	0.2%
1.333	1	0.2%
1.324	1	0.2%
1.321	1	0.2%
1.315	1	0.2%
1.31	1	0.2%

Unleaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price of unleaded fuel, 0 when leaded was used

Distinct	474
Distinct (%)	85.6%
Missing	36
Missing (%)	6.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.773546931

Minimum	0.592
Maximum	4.09
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.592
5-th percentile	0.66665
Q1	1.11925
median	1.327
Q3	2.48375
95-th percentile	3.5907
Maximum	4.09
Range	3.498
Interquartile range (IQR)	1.3645

Descriptive statistics

Standard deviation	0.9010155023
Coefficient of variation (CV)	0.5080302564
Kurtosis	-0.5891162738
Mean	1.773546931
Median Absolute Deviation (MAD)	0.3955
Skewness	0.7944872424
Sum	982.545
Variance	0.8118289354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.955	4	0.7%
1.131	4	0.7%
1.127	3	0.5%
1.207	3	0.5%
1.136	3	0.5%
1.177	3	0.5%
1.255	3	0.5%
1.25	3	0.5%
1.241	3	0.5%
0.665	3	0.5%
Other values (464)	522	88.5%
(Missing)	36	6.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.592	1	0.2%
0.594	1	0.2%
0.6	2	0.3%
0.605	1	0.2%
0.616	1	0.2%
0.623	1	0.2%
0.626	1	0.2%
0.627	1	0.2%
0.628	1	0.2%
0.629	2	0.3%

Value	Count	Frequency (%)
4.09	1	0.2%
4.065	1	0.2%
3.933	1	0.2%
3.927	1	0.2%
3.868	1	0.2%
3.856	1	0.2%
3.816	1	0.2%
3.792	1	0.2%
3.786	2	0.3%
3.764	1	0.2%

Unleaded Premium Gasoline, U.S. City Average Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price of premium unleaded fuel

Distinct	428
Distinct (%)	88.1%
Missing	104
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.15823251

Minimum	0.98
Maximum	4.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.98
5-th percentile	1.115
Q1	1.33625
median	1.6805
Q3	3.00075
95-th percentile	3.9555
Maximum	4.35
Range	3.37
Interquartile range (IQR)	1.6645

Descriptive statistics

Standard deviation	0.9755398661
Coefficient of variation (CV)	0.4520086976
Kurtosis	-1.079366983
Mean	2.15823251
Median Absolute Deviation (MAD)	0.51
Skewness	0.6107838416
Sum	1048.901
Variance	0.9516780304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.421	3	0.5%
1.411	3	0.5%
1.367	3	0.5%
1.268	3	0.5%
1.36	3	0.5%
1.441	2	0.3%
1.323	2	0.3%
1.339	2	0.3%
1.282	2	0.3%
1.1	2	0.3%
Other values (418)	461	78.1%
(Missing)	104	17.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.98	1	0.2%
0.984	1	0.2%
0.987	1	0.2%
0.999	1	0.2%
1.007	1	0.2%
1.01	1	0.2%
1.045	1	0.2%
1.047	1	0.2%
1.052	1	0.2%
1.061	1	0.2%

Value	Count	Frequency (%)
4.35	1	0.2%
4.319	1	0.2%
4.244	1	0.2%
4.194	1	0.2%
4.192	1	0.2%
4.148	1	0.2%
4.14	1	0.2%
4.138	1	0.2%
4.102	1	0.2%
4.1	1	0.2%

All Grades of Gasoline, U.S. City Average Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Cumulative of all grades of gasoline

Distinct	441
Distinct (%)	74.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.741944068

Minimum	0.629
Maximum	4.142
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.629
5-th percentile	0.6406
Q1	1.11975
median	1.3085
Q3	2.4325
95-th percentile	3.6193
Maximum	4.142
Range	3.513
Interquartile range (IQR)	1.31275

Descriptive statistics

Standard deviation	0.9293758199
Coefficient of variation (CV)	0.5335279341
Kurtosis	-0.5415937419
Mean	1.741944068
Median Absolute Deviation (MAD)	0.48
Skewness	0.8022571739
Sum	1027.747
Variance	0.8637394145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.631	12	2.0%
0.629	12	2.0%
0.637	6	1.0%
0.645	6	1.0%
0.655	6	1.0%
0.663	6	1.0%
0.669	6	1.0%
0.671	6	1.0%
0.676	6	1.0%
0.685	6	1.0%
Other values (431)	518	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.629	12	2.0%
0.631	12	2.0%
0.637	6	1.0%
0.645	6	1.0%
0.655	6	1.0%
0.663	6	1.0%
0.669	6	1.0%
0.671	6	1.0%
0.676	6	1.0%
0.685	6	1.0%

Value	Count	Frequency (%)
4.142	1	0.2%
4.115	1	0.2%
3.982	1	0.2%
3.976	1	0.2%
3.918	1	0.2%
3.908	1	0.2%
3.863	1	0.2%
3.839	2	0.3%
3.838	1	0.2%
3.813	1	0.2%

Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price of fuel, non-blended

Distinct	331
Distinct (%)	91.4%
Missing	228
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.098372928

Minimum	0.9
Maximum	4.002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.9
5-th percentile	1.03915
Q1	1.22175
median	2.105
Q3	2.76875
95-th percentile	3.6048
Maximum	4.002
Range	3.102
Interquartile range (IQR)	1.547

Descriptive statistics

Standard deviation	0.8629110184
Coefficient of variation (CV)	0.4112286271
Kurtosis	-1.112339466
Mean	2.098372928
Median Absolute Deviation (MAD)	0.757
Skewness	0.3317638835
Sum	759.611
Variance	0.7446154256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.078	4	0.7%
1.066	3	0.5%
2.488	3	0.5%
2.211	3	0.5%
1.058	2	0.3%
2.48	2	0.3%
2.678	2	0.3%
1.082	2	0.3%
1.199	2	0.3%
3.168	2	0.3%
Other values (321)	337	57.1%
(Missing)	228	38.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.9	1	0.2%
0.917	1	0.2%
0.923	1	0.2%
0.961	1	0.2%
0.979	1	0.2%
0.994	1	0.2%
0.998	1	0.2%
1.006	2	0.3%
1.008	1	0.2%
1.009	1	0.2%

Value	Count	Frequency (%)
4.002	1	0.2%
3.989	1	0.2%
3.849	1	0.2%
3.837	1	0.2%
3.801	1	0.2%
3.774	1	0.2%
3.746	1	0.2%
3.74	1	0.2%
3.735	1	0.2%
3.709	1	0.2%

Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price of fuel, blended

Distinct	311
Distinct (%)	95.4%
Missing	264
Missing (%)	44.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.369110429

Minimum	0.984
Maximum	4.19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.984
5-th percentile	1.11775
Q1	1.51825
median	2.3835
Q3	3.0165
95-th percentile	3.8025
Maximum	4.19
Range	3.206
Interquartile range (IQR)	1.49825

Descriptive statistics

Standard deviation	0.8829988867
Coefficient of variation (CV)	0.3727132664
Kurtosis	-1.155138768
Mean	2.369110429
Median Absolute Deviation (MAD)	0.7605
Skewness	0.1007680195
Sum	772.33
Variance	0.7796870339
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.129	2	0.3%
1.483	2	0.3%
1.5	2	0.3%
1.543	2	0.3%
2.663	2	0.3%
1.114	2	0.3%
1.307	2	0.3%
2.343	2	0.3%
3.202	2	0.3%
2.832	2	0.3%
Other values (301)	306	51.9%
(Missing)	264	44.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.984	1	0.2%
1.008	1	0.2%
1.016	1	0.2%
1.043	1	0.2%
1.045	1	0.2%
1.046	1	0.2%
1.054	1	0.2%
1.057	1	0.2%
1.067	1	0.2%
1.071	1	0.2%

Value	Count	Frequency (%)
4.19	1	0.2%
4.187	1	0.2%
4.032	1	0.2%
4.025	1	0.2%
4.017	1	0.2%
3.949	1	0.2%
3.939	1	0.2%
3.919	1	0.2%
3.914	1	0.2%
3.86	1	0.2%

Regular Motor Gasoline, All Areas, Retail Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Cumulative mean of all categories

Distinct	322
Distinct (%)	89.0%
Missing	228
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.142513812

Minimum	0.921
Maximum	4.062
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.921
5-th percentile	1.0471
Q1	1.23125
median	2.182
Q3	2.80825
95-th percentile	3.66045
Maximum	4.062
Range	3.141
Interquartile range (IQR)	1.577

Descriptive statistics

Standard deviation	0.8830022923
Coefficient of variation (CV)	0.4121337689
Kurtosis	-1.151839223
Mean	2.142513812
Median Absolute Deviation (MAD)	0.785
Skewness	0.2915628142
Sum	775.59
Variance	0.7796930483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.114	4	0.7%
1.078	4	0.7%
2.836	3	0.5%
1.131	3	0.5%
1.111	3	0.5%
1.062	3	0.5%
2.555	3	0.5%
1.969	2	0.3%
1.397	2	0.3%
2.859	2	0.3%
Other values (312)	333	56.4%
(Missing)	228	38.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.921	1	0.2%
0.939	1	0.2%
0.945	1	0.2%
0.982	1	0.2%
0.995	1	0.2%
0.998	1	0.2%
1.006	1	0.2%
1.008	1	0.2%
1.009	2	0.3%
1.013	1	0.2%

Value	Count	Frequency (%)
4.062	1	0.2%
4.054	1	0.2%
3.906	1	0.2%
3.9	1	0.2%
3.852	1	0.2%
3.849	1	0.2%
3.8	1	0.2%
3.779	1	0.2%
3.766	1	0.2%
3.746	1	0.2%

On-Highway Diesel Fuel Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Price for diesel fuel

Distinct	301
Distinct (%)	92.3%
Missing	264
Missing (%)	44.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.445389571

Minimum	0.959
Maximum	4.703
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.7 KiB

Quantile statistics

Minimum	0.959
5-th percentile	1.085
Q1	1.42525
median	2.5105
Q3	3.12825
95-th percentile	3.996
Maximum	4.703
Range	3.744
Interquartile range (IQR)	1.703

Descriptive statistics

Standard deviation	1.000537845
Coefficient of variation (CV)	0.4091527409
Kurtosis	-1.187072514
Mean	2.445389571
Median Absolute Deviation (MAD)	0.937
Skewness	0.1223904225
Sum	797.197
Variance	1.00107598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.12	3	0.5%
3.905	3	0.5%
2.997	2	0.3%
2.785	2	0.3%
1.637	2	0.3%
1.482	2	0.3%
2.519	2	0.3%
3.045	2	0.3%
1.42	2	0.3%
3.069	2	0.3%
Other values (291)	304	51.5%
(Missing)	264	44.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.959	1	0.2%
0.967	1	0.2%
0.973	1	0.2%
0.997	1	0.2%
1.007	1	0.2%
1.022	1	0.2%
1.024	1	0.2%
1.029	1	0.2%
1.039	1	0.2%
1.041	1	0.2%

Value	Count	Frequency (%)
4.703	1	0.2%
4.677	1	0.2%
4.425	1	0.2%
4.302	1	0.2%
4.127	1	0.2%
4.12	1	0.2%
4.115	1	0.2%
4.111	1	0.2%
4.094	1	0.2%
4.084	1	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Date	Leaded Regular Gasoline, U.S. City Average Retail Price	Unleaded Regular Gasoline, U.S. City Average Retail Price	Unleaded Premium Gasoline, U.S. City Average Retail Price	All Grades of Gasoline, U.S. City Average Retail Price	Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price	Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price	Regular Motor Gasoline, All Areas, Retail Price	On-Highway Diesel Fuel Price
0	1973-01-01	0.465	NaN	NaN	0.631	NaN	NaN	NaN	NaN
1	1973-02-01	0.491	NaN	NaN	0.629	NaN	NaN	NaN	NaN
2	1973-03-01	0.528	NaN	NaN	0.629	NaN	NaN	NaN	NaN
3	1973-04-01	0.537	NaN	NaN	0.631	NaN	NaN	NaN	NaN
4	1973-05-01	0.550	NaN	NaN	0.637	NaN	NaN	NaN	NaN
5	1973-06-01	0.556	NaN	NaN	0.645	NaN	NaN	NaN	NaN
6	1973-07-01	0.558	NaN	NaN	0.655	NaN	NaN	NaN	NaN
7	1973-08-01	0.554	NaN	NaN	0.663	NaN	NaN	NaN	NaN
8	1973-09-01	0.550	NaN	NaN	0.669	NaN	NaN	NaN	NaN
9	1973-10-01	0.402	NaN	NaN	0.671	NaN	NaN	NaN	NaN

Last rows

	Date	Leaded Regular Gasoline, U.S. City Average Retail Price	Unleaded Regular Gasoline, U.S. City Average Retail Price	Unleaded Premium Gasoline, U.S. City Average Retail Price	All Grades of Gasoline, U.S. City Average Retail Price	Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price	Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price	Regular Motor Gasoline, All Areas, Retail Price	On-Highway Diesel Fuel Price
580	2021-05-01	NaN	2.972	3.596	3.041	2.885	3.202	2.985	3.217
581	2021-06-01	NaN	3.154	3.802	3.245	2.964	3.281	3.064	3.287
582	2021-07-01	NaN	3.233	3.897	3.326	3.044	3.339	3.136	3.339
583	2021-08-01	NaN	3.255	3.938	3.351	3.062	3.368	3.158	3.350
584	2021-09-01	NaN	3.265	3.945	3.361	3.081	3.382	3.175	3.384
585	2021-10-01	NaN	3.385	4.040	3.477	3.193	3.506	3.291	3.612
586	2021-11-01	NaN	3.482	4.148	3.576	3.275	3.659	3.395	3.727
587	2021-12-01	NaN	3.408	4.100	3.505	3.168	3.608	3.307	3.641
588	2022-01-01	NaN	3.413	4.102	3.500	3.187	3.595	3.315	3.724
589	2022-02-01	NaN	3.592	4.244	3.675	3.400	3.773	3.517	4.032

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows